package com.example.demo.Mappers;

import com.example.demo.beans.WxBillBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by Administrator on 2018-11-18.
 */
@Mapper
public interface WxBillMapper {
    @Select("select createTime as OrderDate, AutoTranNo as OrderNumber,PayAmt as Fee,'10' State  from AutoRegist where  reqtype='1'  and createTime>=#{startDate} and createTime<=#{endDate}")
    List<WxBillBean> GetWxBillBean(@Param("startDate")String startDate,@Param("endDate")String endDate);

}
